Customized Budget Calculations

You can access the budget to create your own budget calculations based on formulas and display them in a column.

You create the column by selecting the Formula column type in the Edit Budget View dialog box. A dialog box for entering the formula opens. The following operators and operands are available:

  • +, -, /, * as well as ( and )

  • Default budget values: Planned, Target, Committed, Actual, Projected budget, Residual Budget and MDF, see chapter Expenses

  • Fees

  • Exchange rates

  • Numbers

Standard budget data, fees and exchange rates are specified on a time basis. Note for planned budgets that the total value of a timeline always used, i.e. the initial planned budget with all planned budget adjustments. Additionally, it is possible to compare budget data from different years. You can choose whether budget data from a specific year or from the selected one is used. This makes it possible, for example, to compare plan data from different years.

For standard budget values, you choose whether the value used in the calculation is the sum of all child elements. You also specify whether the value in the working or reference currency is used for the calculation. If you use the value in the reference currency and the secondary exchange rate is activated in your system, choose between primary and secondary exchange rate.

For exchange rates, you also specify the currency - based on the reference currency - to which the rate should be displayed. If no exchange rate has been defined for the selected currency or time period, then the variable has the value 0. If the use of a secondary exchange rate is activated in your system, you can choose between primary and secondary exchange rate.

Of course, you can also include custom budget calculations in a budget export. See chapter Exporting Planning Data.

You can also choose a color scheme for positive and negative values. By default, positive values are displayed with black font and negative values with red font, both on white background. You can freely choose both the font and the background color.

Example: Net planning

In the Planner, you are managing various campaigns that incur fees. For net requirements planning, you want to view the amount of the budget to be planned in the working currency without the fees. The value should not include the sum of the child elements. The net planned budget is calculated from the following formula:

BNet = BPlanned - (BPlanned * F% + Fabs /(1 + F%))

Net: Net planned budget

Planned: Planned budget

%: Rate of percentage fee

Abs:: Total of the absolute fees

Note that planned budgets and fees must be calculated per month. Since you enter the formula based on time, you must create a column for each month.

For a corresponding example of how to enter the formula above in the Marketing Planner, see chapter Creating Custom Budget Calculations

Note: Prerequisites for correct display is that an administrator has created the fees. In addition, the fees must be assigned to the elements, see chapter Assigning a Fee to an Element and the plan budget for the planning elements must be entered.